
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CRETE PROCEDURE [dbo].[up_PatientsGetNames]

AS
BEGIN
SET NOCOUNT ON;

	SELECT PatientID, ([Name] + ' ' + LastName) AS PatientName
	FROM Patients
	
END


/****** Object:  StoredProcedure [dbo].[up_PatientsUpdate]    Script Date: 12/28/2007 19:54:57 ******/
SET ANSI_NULLS ON



SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[up_PatientsGetByID]
	@PatientID int
AS
BEGIN
SET NOCOUNT ON;

	SELECT *
	FROM Patients
	WHERE PatientID = @PatientID
	
END


/****** Object:  StoredProcedure [dbo].[up_PatientsUpdate]    Script Date: 12/28/2007 19:54:57 ******/
SET ANSI_NULLS ON

